﻿CREATE TABLE [dbo].[personhasassaignedshiftrelationship]
(
	perid int not null,
	shid int not null,
	primary key (perid, shid),
	foreign key (perid) references Person(perid),
	foreign key (shid) references Shift(shid)
)
